﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.Text;

namespace WcfServiceCityDashBoard
{
    // NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "IService1" in both code and config file together.
    [ServiceContract]
    public interface IService1
    {
  

        //------------------------------------------------------
        [OperationContract]
        List<ViewTTTongQuatHPT_entry> getViewTTTongQuatHPT();

        [OperationContract]
        List<View_LoaiHS_trinhUB_DungHan_HPT_entry> getView_LoaiHS_trinhUB_DungHan_HPT();



        [OperationContract]
         List<ViewDADT_byloaiDN_HPT_entry> getViewDADT_byloaiDN_HPT();
        
         [OperationContract]
        List<ViewDADT_bymonth_HPT_entry> getViewDADT_bymonth_HPT();
        
        [OperationContract]
         List<ViewDADT_byTenloaiHinhDT_HPT_entry> getViewDADT_byTenloaiHinhDT_HPT();
        
         [OperationContract]
        List<ViewDADT_byTenloaiHinhDT_USD_HPT_entry> getViewDADT_byTenloaiHinhDT_USD_HPT();
        [OperationContract]
         List<ViewDADT_byTenNganh_HPT_entry> getViewDADT_byTenNganh_HPT();
        
        [OperationContract]
        List<ViewDADT_byTenNganh_USD_HPT_entry> getViewDADT_byTenNganh_USD_HPT();
        
        [OperationContract]
        List<ViewDADT_byTenQuan_HPT_entry> getViewDADT_byTenQuan_HPT();
        
        [OperationContract]
        List<ViewDADT_byTenQuan_USD_HPT_entry> getViewDADT_byTenQuan_USD_HPT();
        
        [OperationContract]
        List<ViewDADT_byTenQuocTich_BC_HPT_entry> getViewDADT_byTenQuocTich_BC_HPT();

        [OperationContract]
        List<ViewDADT_top5DAdautu_HPT_entry> getViewDADT_top5DAdautu_HPT();

        
         [OperationContract]
        List<ViewDADT_byTenQuocTich_BC_USD_HPT_entry> getViewDADT_byTenQuocTich_BC_USD_HPT();


         [OperationContract]
         List<View_HSDangGiaiQuyet_HPT_entry> getView_HSDangGiaiQuyet_HPT();

         [OperationContract]
         List<View_HSDangGiaiQuyet_HPT_entry> getView_HSDangGiaiQuyetDetail_HPT(string filter);

         [OperationContract]
         List<View_HSDangGiaiQuyet_HPT_entry> getView_ThongTinHSDetail_HPT(int loai_hs, int IsTrinhUB, int IsDungHan);


         [OperationContract]
         List<View_DangGiaiQuyetDetailHS_HPT_entry> getView_DangGiaiQuyetDetailOneHS_HPT(string filter);

         [OperationContract]
         List<View_hsDungTreHenHangThang_HPT_entry> getView_hsDungTreHenHangThang_HPT();

      

     #region LINQ
         [OperationContract]
        int GetTongHosoNhan();

        [OperationContract]
        int GetGQDungHan();
        [OperationContract]
        int GetGQTreHan();
        [OperationContract]
        int GetChuaGQQuaHan();
        [OperationContract]
        int GetChuaGQTrongHan();


        [OperationContract]
        int GetHStrinhUBND();

        [OperationContract]
        int GetHStrinhUBND_DangGQtre();

        [OperationContract]
        int GetHStrinhUBND_tre();

        [OperationContract]
        int GetHSChuatrinhUBND_tre();

        [OperationContract]
        int GetHSChuatrinhUBND();


        [OperationContract]
        int GetHStrinhUBND_dagiaiquyet();

        [OperationContract]
        int GetHStrinhUBND_chuagiaiquyet();

        [OperationContract]
        int GetHStrinhKHDT();

        [OperationContract]
        int GetHStrinhKHDT_dagiaiquyet();

        [OperationContract]
        int GetHStrinhKHDT_chuagiaiquyet();

        [OperationContract]
        List<View_TrinhUBND> DagqUBND();
        [OperationContract]
        List<View_TrinhUBND> ChuagqUBND();

        [OperationContract]
        List<View_TrinhUBND> HStrinhUBNDTP();
        [OperationContract]
        List<View_TrinhUBND> HSChuatrinhUBNDTP();

        [OperationContract]
        List<View_TrinhUBND> HsDaGiaiQuyet();

        [OperationContract]
        List<View_TrinhUBND> HsDangGiaiQuyet();

        [OperationContract]
        int GetTongDADTthang();

        [OperationContract]
        int GetDuanHieuLuc();

        [OperationContract]
        float GetDuanHieuLuc_usd();

        [OperationContract]
        int DoanhNghiepHoatDong();

        [OperationContract]
        float DoanhNghiepHoatDong_usd();


        [OperationContract]
        int GetDuanGiaiThe();

        [OperationContract]
        float GetDuanGiaithe_usd();

        [OperationContract]
        int GetDuanCapmoi();

        [OperationContract]
        float GetDuanCapmoi_usd();

        [OperationContract]
        int GettongDuanbyDN();

        [OperationContract]
        int GettongDuanbyDT();

        [OperationContract]
        float GettongDuanbyDN_usd();

        [OperationContract]
        float GettongDuanbyDT_usd();

        [OperationContract]
        int GetHepza();

        [OperationContract]
        float GetHepza_usd();

        [OperationContract]
        int GetSHTP();

        [OperationContract]
        float GetSHTP_usd();

        [OperationContract]
        int Getothers();

        [OperationContract]
        float Getothers_usd();



#endregion

    }

    // Use a data contract as illustrated in the sample below to add composite types to service operations.
    // You can add XSD files into the project. After building the project, you can directly use the data types defined there, with the namespace "WcfServiceCityDashBoard.ContractType".
    [DataContract]

    //View ViewTTTongQuatHPT
    public class ViewTTTongQuatHPT_entry
    {
        int _id;
        string _loai_hs;
        int _soluong_tt;
        int _soluong_dunghan;
        int _soluong_trehan;
        string _percent_soluong_dunghan;
        string _percent_soluong_trehan;


        [DataMember]
        public string loai_hs
        {
            get { return _loai_hs; }
            set { _loai_hs = value; }
        }

        [DataMember]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }

        [DataMember]
        public int soluong_tt
        {
            get { return _soluong_tt; }
            set { _soluong_tt = value; }
        }

        [DataMember]
        public int soluong_dunghan
        {
            get { return _soluong_dunghan; }
            set { _soluong_dunghan = value; }
        }

        [DataMember]
        public int soluong_trehan
        {
            get { return _soluong_trehan; }
            set { _soluong_trehan = value; }
        }

        [DataMember]
        public string percent_soluong_dunghan
        {
            get { return _percent_soluong_dunghan; }
            set { _percent_soluong_dunghan = value; }
        }

        [DataMember]
        public string percent_soluong_trehan
        {
            get { return _percent_soluong_trehan; }
            set { _percent_soluong_trehan = value; }
        }
    }

    //View View_LoaiHS_trinhUB_DungHan_HPT
    public class View_LoaiHS_trinhUB_DungHan_HPT_entry
    {
        int _id;
        int _loai_hs;
        string _loai_hs_desc;
        int _trinhUBND;
        string _trinhUBND_desc;
        int _TT_DungHan;
        string _TT_DungHan_desc;
        int _soluong;

        [DataMember]
        public int Soluong
        {
            get { return _soluong; }
            set { _soluong = value; }
        }


        [DataMember]
        public int loai_hs
        {
            get { return _loai_hs; }
            set { _loai_hs = value; }
        }

        [DataMember]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }

        [DataMember]
        public string loai_hs_desc
        {
            get { return _loai_hs_desc; }
            set { _loai_hs_desc = value; }
        }

        [DataMember]
        public int trinhUBND
        {
            get { return _trinhUBND; }
            set { _trinhUBND = value; }
        }

        [DataMember]
        public string trinhUBND_desc
        {
            get { return _trinhUBND_desc; }
            set { _trinhUBND_desc = value; }
        }

        [DataMember]
        public int TT_DungHan
        {
            get { return _TT_DungHan; }
            set { _TT_DungHan = value; }
        }

        [DataMember]
        public string TT_DungHan_desc
        {
            get { return _TT_DungHan_desc; }
            set { _TT_DungHan_desc = value; }
        }
    }



//-----------------------------------------------------------------------------


    //---------------------------------------------------------------------------------------

     public class ViewDADT_byloaiDN_HPT_entry
     {
         string _tenloaidn;
         int _SL;

         [DataMember]
         public string tenloaidn
         {
             get { return _tenloaidn; }
             set { _tenloaidn = value; }
         }

         
         [DataMember]
         public int SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

     public class ViewDADT_bymonth_HPT_entry
     {
         int _sl;
         int _thang;
         int _nam;

         [DataMember]
         public int sl
         {
             get { return _sl; }
             set { _sl = value; }
         }

         [DataMember]
         public int thang
         {
             get { return _thang; }
             set { _thang = value; }
         }

         [DataMember]
         public int nam
         {
             get { return _nam; }
             set { _nam = value; }
         }
     }

     public class ViewDADT_byTenloaiHinhDT_HPT_entry
     {
         string _tenloaihinhDT;
         int _SL;

         [DataMember]
         public string tenloaihinhDT
         {
             get { return _tenloaihinhDT; }
             set { _tenloaihinhDT = value; }
         }

         
         [DataMember]
         public int SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenloaiHinhDT_USD_HPT_entry
     {
         string _tenloaihinhDT;
         float _SL;

         [DataMember]
         public string tenloaihinhDT
         {
             get { return _tenloaihinhDT; }
             set { _tenloaihinhDT = value; }
         }

         
         [DataMember]
         public float SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenNganh_HPT_entry
     {
         string _tennganh;
         int _SL;

         [DataMember]
         public string tennganh
         {
             get { return _tennganh; }
             set { _tennganh = value; }
         }

         
         [DataMember]
         public int SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenNganh_USD_HPT_entry
     {
         string _tennganh;
         float _SL;

         [DataMember]
         public string tennganh
         {
             get { return _tennganh; }
             set { _tennganh = value; }
         }

         
         [DataMember]
         public float SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenQuan_HPT_entry
     {
         string _tenquan;
         int _SL;

         [DataMember]
         public string tenquan
         {
             get { return _tenquan; }
             set { _tenquan = value; }
         }

         
         [DataMember]
         public int SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenQuan_USD_HPT_entry
     {
         string _tenquan;
         float _SL;

         [DataMember]
         public string tenquan
         {
             get { return _tenquan; }
             set { _tenquan = value; }
         }

         
         [DataMember]
         public float SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenQuocTich_BC_HPT_entry
     {
        int _id;
         string _tenquoctich_BC;
         int _SL;

         [DataMember]
         public int Id
         {
             get { return _id; }
             set { _id = value; }
         }

         [DataMember]
         public string tenquoctich_BC
         {
             get { return _tenquoctich_BC; }
             set { _tenquoctich_BC = value; }
         }

         
         [DataMember]
         public int SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_byTenQuocTich_BC_USD_HPT_entry
     {
         string _tenquoctich_BC;
         float _SL;

         [DataMember]
         public string tenquoctich_BC
         {
             get { return _tenquoctich_BC; }
             set { _tenquoctich_BC = value; }
         }

         
         [DataMember]
         public float SL
         {
             get { return _SL; }
             set { _SL = value; }
         }
     }

    public class ViewDADT_top5DAdautu_HPT_entry
    {
        string _sobnhan;
        string _tenduandautu;
        float _tongvonUSD;

        [DataMember]
        public string Sobnhan
        {
            get { return _sobnhan; }
            set { _sobnhan = value; }
        }

        [DataMember]
        public string TenDuanDauTu
        {
            get { return _tenduandautu; }
            set { _tenduandautu = value; }
        }


        [DataMember]
        public float TongvonUSD
        {
            get { return _tongvonUSD; }
            set { _tongvonUSD = value; }
        }
    }

    //--------------------------------------------------------------------------------

    //---------------------------------------------------------------------------------

    public class View_HSDangGiaiQuyet_HPT_entry
    {
        int _id;
        int _type;
        string _trangthai_hs;
        string _sobnhan;
        string _xuly;
        int _SL;
        int _typeTT;

        string _tendn;
        string _tenda;
        string _ngaynhan;
        string _ngaytra;

        [DataMember]
        public string tendn
        {
            get { return _tendn; }
            set { _tendn = value; }
        }
        [DataMember]
        public string tenda
        {
            get { return _tenda; }
            set { _tenda = value; }
        }

        [DataMember]
        public string ngaynhan
        {
            get { return _ngaynhan; }
            set { _ngaynhan = value; }
        }
        [DataMember]
        public string ngaytra
        {
            get { return _ngaytra; }
            set { _ngaytra = value; }
        }
        [DataMember]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }


        [DataMember]
        public int type
        {
            get { return _type; }
            set { _type = value; }
        }

        [DataMember]
        public string sobnhan
        {
            get { return _sobnhan; }
            set { _sobnhan = value; }
        }

        [DataMember]
        public string trangthai_hs
        {
            get { return _trangthai_hs; }
            set { _trangthai_hs = value; }
        }

        [DataMember]
        public string xuly
        {
            get { return _xuly; }
            set { _xuly = value; }
        }

        [DataMember]
        public int SL
        {
            get { return _SL; }
            set { _SL = value; }
        }
        [DataMember]
        public int typeTT
        {
            get { return _typeTT; }
            set { _typeTT = value; }
        }
    }

    public class View_DangGiaiQuyetDetailHS_HPT_entry
    {
        int _id;
        string _trangthai_hs;
        string _ngayxuly;
        string _tenchuyenvien;

        [DataMember]
        public int Id
        {
            get { return _id; }
            set { _id = value; }
        }

        [DataMember]
        public string TrangthaiXuly
        {
            get { return _trangthai_hs; }
            set { _trangthai_hs = value; }
        }

        [DataMember]
        public string Tennhanvien
        {
            get { return _tenchuyenvien; }
            set { _tenchuyenvien = value; }
        }

        [DataMember]
        public string Ngayxuly
        {
            get { return _ngayxuly; }
            set { _ngayxuly = value; }
        }
    }

    public class View_hsDungTreHenHangThang_HPT_entry
    {
        int _ketqua_xuly;
        string _ketqua_xuly_desc;
        int _thang;
        int _nam;
        int _SL;


        [DataMember]
        public int ketqua_xuly
        {
            get { return _ketqua_xuly; }
            set { _ketqua_xuly = value; }
        }

        [DataMember]
        public string ketqua_xuly_desc
        {
            get { return _ketqua_xuly_desc; }
            set { _ketqua_xuly_desc = value; }
        }

        [DataMember]
        public int thang
        {
            get { return _thang; }
            set { _thang = value; }
        }

        [DataMember]
        public int nam
        {
            get { return _nam; }
            set { _nam = value; }
        }

        [DataMember]
        public int SL
        {
            get { return _SL; }
            set { _SL = value; }
        }
    }
    

    #region Old Data
    public class View_TrinhUBND
    {
        string _name;
        int _sl;

        [DataMember]
        public string Name
        {
            get { return _name; }
            set { _name = value; }
        }

        [DataMember]
        public int Soluong
        {
            get { return _sl; }
            set { _sl = value; }
        }

    }

   
#endregion
}
